... like 'ADDITIONAL TIMETABLE%'
AND tt.[RoomId] ''
AND sd.[SourcesId]='RB'
AND tt.[SiteId]='LC'
AND (
dateadd(d, tt.[WeekDay] - 1, (SELECT TOP 1 StartDate FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] ...
... sd.[SetId] = @setId
AND dateadd(d, tt.[WeekDay] - 1, @baseDate) = @GivenDate
AND wm.[WeekNumber] = @weekNumber
AND tt.[SiteId] = @siteId
AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%'
...
... tt.[SiteId] = @siteId
AND tt.[Status] 3 -- Remove cancelled bookings
AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%'
ORDER BY Date ASC, Room ASC,
tt.[StartTime] ASC,
tt.[FinishTime] ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.